﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Users" targetNamespace="http://tempuri.org/Users.xsd" xmlns:mstns="http://tempuri.org/Users.xsd" xmlns="http://tempuri.org/Users.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ILEConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ILEConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ILEConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillUsers" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetUsers" GeneratorSourceName="FillUsers" GetMethodModifier="Public" GetMethodName="GetUsers" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetUsers" UserSourceName="FillUsers">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Users] WHERE (([UserID] = @Original_UserID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Users] ([Username], [AccountType], [FirstName], [LastName], [Email], [StudentIDNumber], [Year], [IsEnabled]) VALUES (@Username, @AccountType, @FirstName, @LastName, @Email, @StudentIDNumber, @Year, @IsEnabled)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AccountType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AccountType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StudentIDNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StudentIDNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Year" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsEnabled" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsEnabled" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     UserID, Username, AccountType, FirstName, LastName, Email, StudentIDNumber, Year, IsEnabled
FROM         Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Users] SET [Username] = @Username, [AccountType] = @AccountType, [FirstName] = @FirstName, [LastName] = @LastName, [Email] = @Email, [StudentIDNumber] = @StudentIDNumber, [Year] = @Year, [IsEnabled] = @IsEnabled WHERE (([UserID] = @Original_UserID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AccountType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AccountType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StudentIDNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StudentIDNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Year" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsEnabled" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsEnabled" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="AccountType" DataSetColumn="AccountType" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="StudentIDNumber" DataSetColumn="StudentIDNumber" />
              <Mapping SourceColumn="IsEnabled" DataSetColumn="IsEnabled" />
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteUser" Modifier="Public" Name="DeleteUser" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteUser">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [Users] WHERE (([UserID] = @UserID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillUserByUserID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetUserByUserID" GeneratorSourceName="FillUserByUserID" GetMethodModifier="Public" GetMethodName="GetUserByUserID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetUserByUserID" UserSourceName="FillUserByUserID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AccountType, Email, FirstName, IsEnabled, LastName, StudentIDNumber, UserID, Username, Year FROM Users WHERE (UserID = @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillUserByUsername" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetUserByUsername" GeneratorSourceName="FillUserByUsername" GetMethodModifier="Public" GetMethodName="GetUserByUsername" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetUserByUsername" UserSourceName="FillUserByUsername">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AccountType, Email, FirstName, IsEnabled, LastName, StudentIDNumber, UserID, Username, Year FROM Users WHERE (Username = @Username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Username" ColumnName="Username" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillUsersByAccountType" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetUsersByAccountType" GeneratorSourceName="FillUsersByAccountType" GetMethodModifier="Public" GetMethodName="GetUsersByAccountType" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetUsersByAccountType" UserSourceName="FillUsersByAccountType">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     AccountType, Email, FirstName, IsEnabled, LastName, StudentIDNumber, UserID, Username, Year
FROM         Users
WHERE     (AccountType = @AccountType)
ORDER BY LastName</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AccountType" ColumnName="AccountType" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\MY DROPBOX\WORK\LIDEV\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(15)" DbType="AnsiString" Direction="Input" ParameterName="@AccountType" Precision="0" ProviderType="VarChar" Scale="0" Size="15" SourceColumn="AccountType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertUser" Modifier="Public" Name="InsertUser" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertUser">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO Users
                      (Username, AccountType, FirstName, LastName, Email, StudentIDNumber, Year, IsEnabled)
VALUES     (@Username,@AccountType,@FirstName,@LastName,@Email,@StudentIDNumber,@Year,@IsEnabled);  

SELECT SCOPE_IDENTITY()</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Username" ColumnName="Username" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="AccountType" ColumnName="AccountType" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(15)" DbType="AnsiString" Direction="Input" ParameterName="@AccountType" Precision="0" ProviderType="VarChar" Scale="0" Size="15" SourceColumn="AccountType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="FirstName" ColumnName="FirstName" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="LastName" ColumnName="LastName" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Email" ColumnName="Email" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="StudentIDNumber" ColumnName="StudentIDNumber" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@StudentIDNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="StudentIDNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Year" ColumnName="Year" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Year" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IsEnabled" ColumnName="IsEnabled" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsEnabled" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsEnabled" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="IsUserInTable" Modifier="Public" Name="IsUserInTable" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="IsUserInTable">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) FROM Users
WHERE Username=@Username</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Username" ColumnName="Username" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateUserByUserID" Modifier="Public" Name="UpdateUserByUserID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="UpdateUserByUserID">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Users
SET              Username = @Username, AccountType = @AccountType, FirstName = @FirstName, LastName = @LastName, Email = @Email, 
                      StudentIDNumber = @StudentIDNumber, Year = @Year, IsEnabled = @IsEnabled
WHERE     (UserID = @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Username" ColumnName="Username" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="AccountType" ColumnName="AccountType" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(15)" DbType="AnsiString" Direction="Input" ParameterName="@AccountType" Precision="0" ProviderType="VarChar" Scale="0" Size="15" SourceColumn="AccountType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="FirstName" ColumnName="FirstName" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="LastName" ColumnName="LastName" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Email" ColumnName="Email" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="StudentIDNumber" ColumnName="StudentIDNumber" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@StudentIDNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="StudentIDNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Year" ColumnName="Year" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Year" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IsEnabled" ColumnName="IsEnabled" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsEnabled" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsEnabled" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateUserByUsername" Modifier="Public" Name="UpdateUserByUsername" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="UpdateUserByUsername">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Users
SET              AccountType = @AccountType, FirstName = @FirstName, LastName = @LastName, Email = @Email, StudentIDNumber = @StudentIDNumber, 
                      Year = @Year, IsEnabled = @IsEnabled
WHERE     (Username = @Username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AccountType" ColumnName="AccountType" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(15)" DbType="AnsiString" Direction="Input" ParameterName="@AccountType" Precision="0" ProviderType="VarChar" Scale="0" Size="15" SourceColumn="AccountType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="FirstName" ColumnName="FirstName" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="LastName" ColumnName="LastName" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Email" ColumnName="Email" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="StudentIDNumber" ColumnName="StudentIDNumber" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@StudentIDNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="StudentIDNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Year" ColumnName="Year" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Year" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IsEnabled" ColumnName="IsEnabled" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsEnabled" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsEnabled" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Username" ColumnName="Username" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Users_NonInstituteTableAdapter" GeneratorDataComponentClassName="Users_NonInstituteTableAdapter" Name="Users_NonInstitute" UserDataComponentName="Users_NonInstituteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillUsers" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetUsers" GeneratorSourceName="FillUsers" GetMethodModifier="Public" GetMethodName="GetUsers" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetUsers" UserSourceName="FillUsers">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Users.UserID, Users.Username, Users.AccountType, Users.FirstName, Users.LastName, Users.Email, Users.StudentIDNumber, Users.IsEnabled, 
                      Users_NonInstitute.Password, Users_NonInstitute.Organization, Users_NonInstitute.SecurityQuestion, Users_NonInstitute.SecurityAnswer, 
                      Users.Year
FROM         Users INNER JOIN
                      Users_NonInstitute ON Users.UserID = Users_NonInstitute.UserID</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="AccountType" DataSetColumn="AccountType" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="StudentIDNumber" DataSetColumn="StudentIDNumber" />
              <Mapping SourceColumn="IsEnabled" DataSetColumn="IsEnabled" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="Organization" DataSetColumn="Organization" />
              <Mapping SourceColumn="SecurityQuestion" DataSetColumn="SecurityQuestion" />
              <Mapping SourceColumn="SecurityAnswer" DataSetColumn="SecurityAnswer" />
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="Activation" Modifier="Public" Name="Activation" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="Activation">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM Users_NonInstitute_Activation
WHERE     (UserID = @UserID) AND (ActivationCode = @ActivationCode)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users_NonInstitute_Activation" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ActivationCode" ColumnName="ActivationCode" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users_NonInstitute_Activation" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@ActivationCode" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="ActivationCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="Authentication" Modifier="Public" Name="Authentication" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="Authentication">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(*) AS Expr1
FROM         Users INNER JOIN
                      Users_NonInstitute ON Users.UserID = Users_NonInstitute.UserID
WHERE     (Users.Username = @Username) AND (Users_NonInstitute.Password = @Password)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Username" ColumnName="Username" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Password" ColumnName="Password" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users_NonInstitute" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillUserByUserID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetUserByUserID" GeneratorSourceName="FillUserByUserID" GetMethodModifier="Public" GetMethodName="GetUserByUserID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetUserByUserID" UserSourceName="FillUserByUserID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Users.UserID, Users.Username, Users.AccountType, Users.FirstName, Users.LastName, Users.Email, Users.StudentIDNumber, Users.IsEnabled, 
                      Users_NonInstitute.Password, Users_NonInstitute.Organization, Users_NonInstitute.SecurityQuestion, Users_NonInstitute.SecurityAnswer, 
                      Users.Year
FROM         Users INNER JOIN
                      Users_NonInstitute ON Users.UserID = Users_NonInstitute.UserID
WHERE     (Users.UserID = @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillUserByUsername" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetUserByUsername" GeneratorSourceName="FillUserByUsername" GetMethodModifier="Public" GetMethodName="GetUserByUsername" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetUserByUsername" UserSourceName="FillUserByUsername">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Users.UserID, Users.Username, Users.AccountType, Users.FirstName, Users.LastName, Users.Email, Users.StudentIDNumber, Users.IsEnabled, 
                      Users_NonInstitute.Password, Users_NonInstitute.Organization, Users_NonInstitute.SecurityQuestion, Users_NonInstitute.SecurityAnswer, 
                      Users.Year
FROM         Users INNER JOIN
                      Users_NonInstitute ON Users.UserID = Users_NonInstitute.UserID
WHERE     (Users.Username = @Username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Username" ColumnName="Username" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertNonInstituteInfo" Modifier="Public" Name="InsertNonInstituteInfo" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="InsertNonInstituteInfo">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO Users_NonInstitute
                      (UserID, Password, Organization, SecurityQuestion, SecurityAnswer)
VALUES     (@UserID,@Password,@Organization,@SecurityQuestion,@SecurityAnswer)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users_NonInstitute" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Password" ColumnName="Password" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users_NonInstitute" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Organization" ColumnName="Organization" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users_NonInstitute" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Organization" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Organization" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="SecurityQuestion" ColumnName="SecurityQuestion" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users_NonInstitute" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@SecurityQuestion" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="SecurityQuestion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="SecurityAnswer" ColumnName="SecurityAnswer" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users_NonInstitute" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@SecurityAnswer" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="SecurityAnswer" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdatePassword" Modifier="Public" Name="UpdatePassword" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="UpdatePassword">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Users_NonInstitute
SET              Password = @Password
WHERE     (UserID = @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Password" ColumnName="Password" DataSourceName="[ILE3.0dev].dbo.Users_NonInstitute" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[ILE3.0dev].dbo.Users_NonInstitute" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Relations_Course-UserTableAdapter" GeneratorDataComponentClassName="Relations_Course_UserTableAdapter" Name="Relations_Course-User" UserDataComponentName="Relations_Course-UserTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.[Relations_Course-User]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCourseUserRelations" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCourseUserRelations" GeneratorSourceName="FillCourseUserRelations" GetMethodModifier="Public" GetMethodName="GetCourseUserRelations" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetCourseUserRelations" UserSourceName="FillCourseUserRelations">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Relations_Course-User] WHERE (([CourseID] = @Original_CourseID) AND ([SectionNumber] = @Original_SectionNumber) AND ([UserID] = @Original_UserID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Relations_Course-User] ([CourseID], [SectionNumber], [UserID], [Type], [SortOrder]) VALUES (@CourseID, @SectionNumber, @UserID, @Type, @SortOrder)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SortOrder" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SortOrder" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        [Relations_Course-User].*
FROM            [Relations_Course-User]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Relations_Course-User] SET [CourseID] = @CourseID, [SectionNumber] = @SectionNumber, [UserID] = @UserID, [Type] = @Type, [SortOrder] = @SortOrder WHERE (([CourseID] = @Original_CourseID) AND ([SectionNumber] = @Original_SectionNumber) AND ([UserID] = @Original_UserID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SortOrder" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SortOrder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
              <Mapping SourceColumn="SectionNumber" DataSetColumn="SectionNumber" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="SortOrder" DataSetColumn="SortOrder" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteCourseUserRelation" Modifier="Public" Name="DeleteCourseUserRelation" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteCourseUserRelation">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [Relations_Course-User] WHERE (([CourseID] = @Original_CourseID) AND ([SectionNumber] = @Original_SectionNumber) AND ([UserID] = @Original_UserID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_UserID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteCourseUserRelationsByCourseIDAndUserIDAndType" Modifier="Public" Name="DeleteCourseUserRelationsByCourseIDAndUserIDAndType" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="DeleteCourseUserRelationsByCourseIDAndUserIDAndType">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [Relations_Course-User] WHERE (([CourseID] = @Original_CourseID) AND ([UserID] = @Original_UserID)) AND Type = @Type</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_UserID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Type" ColumnName="Type" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.[Relations_Course-User]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCourseUserRelationsByCourseIDAndSectionNumber" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCourseUserRelationsByCourseIDAndSectionNumber" GeneratorSourceName="FillCourseUserRelationsByCourseIDAndSectionNumber" GetMethodModifier="Public" GetMethodName="GetCourseUserRelationsByCourseIDAndSectionNumber" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCourseUserRelationsByCourseIDAndSectionNumber" UserSourceName="FillCourseUserRelationsByCourseIDAndSectionNumber">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        [Relations_Course-User].*
FROM            [Relations_Course-User]
WHERE CourseID = @CourseID AND SectionNumber = @SectionNumber</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.[Relations_Course-User]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCourseUserRelationsByCourseIDAndSectionNumberAndType" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCourseUserRelationsByCourseIDAndSectionNumberAndType" GeneratorSourceName="FillCourseUserRelationsByCourseIDAndSectionNumberAndType" GetMethodModifier="Public" GetMethodName="GetCourseUserRelationsByCourseIDAndSectionNumberAndType" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCourseUserRelationsByCourseIDAndSectionNumberAndType" UserSourceName="FillCourseUserRelationsByCourseIDAndSectionNumberAndType">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        [Relations_Course-User].*
FROM            [Relations_Course-User]
WHERE CourseID = @CourseID AND SectionNumber = @SectionNumber AND Type=@Type</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Type" ColumnName="Type" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.[Relations_Course-User]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCourseUserRelationsByCourseIdAndSectionNumberAndUserId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCourseUserRelationsByCourseIdAndSectionNumberAndUserId" GeneratorSourceName="FillCourseUserRelationsByCourseIdAndSectionNumberAndUserId" GetMethodModifier="Public" GetMethodName="GetCourseUserRelationsByCourseIdAndSectionNumberAndUserId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCourseUserRelationsByCourseIdAndSectionNumberAndUserId" UserSourceName="FillCourseUserRelationsByCourseIdAndSectionNumberAndUserId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        [Relations_Course-User].*
FROM            [Relations_Course-User]
WHERE CourseID = @CourseID AND SectionNumber = @SectionNumber AND UserID = @UserID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.[Relations_Course-User]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCourseUserRelationsByCourseIDAndUserIDAndType" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCourseUserRelationsByCourseIDAndUserIDAndType" GeneratorSourceName="FillCourseUserRelationsByCourseIDAndUserIDAndType" GetMethodModifier="Public" GetMethodName="GetCourseUserRelationsByCourseIDAndUserIDAndType" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCourseUserRelationsByCourseIDAndUserIDAndType" UserSourceName="FillCourseUserRelationsByCourseIDAndUserIDAndType">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        [Relations_Course-User].*
FROM            [Relations_Course-User]
WHERE CourseID = @CourseID AND UserID = @UserID AND Type = @Type</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Type" ColumnName="Type" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.[Relations_Course-User]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCourseUserRelationsByUserIdAndType" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCourseUserRelationsByUserIdAndType" GeneratorSourceName="FillCourseUserRelationsByUserIdAndType" GetMethodModifier="Public" GetMethodName="GetCourseUserRelationsByUserIdAndType" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCourseUserRelationsByUserIdAndType" UserSourceName="FillCourseUserRelationsByUserIdAndType">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     CourseID, SectionNumber, UserID, Type, SortOrder
FROM         [Relations_Course-User]
WHERE     (UserID = @UserID) AND (Type = @Type)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Type" ColumnName="Type" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateCourseUserRelationCourseIdAndSectionNumberByCourseIdAndSectionNumberAndUserId" Modifier="Public" Name="UpdateCourseUserRelationCourseIdAndSectionNumberByCourseIdAndSectionNumberAndUserId" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateCourseUserRelationCourseIdAndSectionNumberByCourseIdAndSectionNumberAndUserId">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    [Relations_Course-User]
SET              CourseID = @CourseID, SectionNumber = @SectionNumber
WHERE     (CourseID = @Original_CourseID) AND (SectionNumber = @Original_SectionNumber) AND (UserID = @Original_UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_UserID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.[Relations_Course-User]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Users_NonInstitute_ActivationTableAdapter" GeneratorDataComponentClassName="Users_NonInstitute_ActivationTableAdapter" Name="Users_NonInstitute_Activation" UserDataComponentName="Users_NonInstitute_ActivationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Users_NonInstitute_Activation" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillActivationCode" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetActivationCode" GeneratorSourceName="FillActivationCode" GetMethodModifier="Public" GetMethodName="GetActivationCode" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetActivationCode" UserSourceName="FillActivationCode">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Users_NonInstitute_Activation] WHERE (([UserID] = @Original_UserID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Users_NonInstitute_Activation] ([UserID], [ActivationCode]) VALUES (@UserID, @ActivationCode)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ActivationCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ActivationCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     UserID, ActivationCode
FROM         Users_NonInstitute_Activation
WHERE     (UserID = @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users_NonInstitute_Activation" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Users_NonInstitute_Activation] SET [UserID] = @UserID, [ActivationCode] = @ActivationCode WHERE (([UserID] = @Original_UserID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ActivationCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ActivationCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="ActivationCode" DataSetColumn="ActivationCode" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertActivationCode" Modifier="Public" Name="InsertActivationCode" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertActivationCode">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO Users_NonInstitute_Activation
                      (UserID, ActivationCode)
VALUES     (@UserID,@ActivationCode)
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users_NonInstitute_Activation" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ActivationCode" ColumnName="ActivationCode" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Users_NonInstitute_Activation" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@ActivationCode" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="ActivationCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Users" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="Users" msprop:Generator_DataSetName="Users">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Users" msprop:Generator_UserTableName="Users" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowClassName="UsersRow" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_TablePropName="_Users">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" type="xs:int" />
              <xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccountType" msprop:Generator_UserColumnName="AccountType" msprop:Generator_ColumnVarNameInTable="columnAccountType" msprop:Generator_ColumnPropNameInRow="AccountType" msprop:Generator_ColumnPropNameInTable="AccountTypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StudentIDNumber" msprop:Generator_UserColumnName="StudentIDNumber" msprop:Generator_ColumnVarNameInTable="columnStudentIDNumber" msprop:Generator_ColumnPropNameInRow="StudentIDNumber" msprop:Generator_ColumnPropNameInTable="StudentIDNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsEnabled" msprop:Generator_UserColumnName="IsEnabled" msprop:Generator_ColumnVarNameInTable="columnIsEnabled" msprop:Generator_ColumnPropNameInRow="IsEnabled" msprop:Generator_ColumnPropNameInTable="IsEnabledColumn" type="xs:boolean" />
              <xs:element name="Year" msprop:Generator_UserColumnName="Year" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInTable="YearColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users_NonInstitute" msprop:Generator_UserTableName="Users_NonInstitute" msprop:Generator_RowDeletedName="Users_NonInstituteRowDeleted" msprop:Generator_RowChangedName="Users_NonInstituteRowChanged" msprop:Generator_RowClassName="Users_NonInstituteRow" msprop:Generator_RowChangingName="Users_NonInstituteRowChanging" msprop:Generator_RowEvArgName="Users_NonInstituteRowChangeEvent" msprop:Generator_RowEvHandlerName="Users_NonInstituteRowChangeEventHandler" msprop:Generator_TableClassName="Users_NonInstituteDataTable" msprop:Generator_TableVarName="tableUsers_NonInstitute" msprop:Generator_RowDeletingName="Users_NonInstituteRowDeleting" msprop:Generator_TablePropName="Users_NonInstitute">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" type="xs:int" />
              <xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccountType" msprop:Generator_UserColumnName="AccountType" msprop:Generator_ColumnVarNameInTable="columnAccountType" msprop:Generator_ColumnPropNameInRow="AccountType" msprop:Generator_ColumnPropNameInTable="AccountTypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StudentIDNumber" msprop:Generator_UserColumnName="StudentIDNumber" msprop:Generator_ColumnVarNameInTable="columnStudentIDNumber" msprop:Generator_ColumnPropNameInRow="StudentIDNumber" msprop:Generator_ColumnPropNameInTable="StudentIDNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsEnabled" msprop:Generator_UserColumnName="IsEnabled" msprop:Generator_ColumnVarNameInTable="columnIsEnabled" msprop:Generator_ColumnPropNameInRow="IsEnabled" msprop:Generator_ColumnPropNameInTable="IsEnabledColumn" type="xs:boolean" />
              <xs:element name="Password" msprop:Generator_UserColumnName="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Organization" msprop:Generator_UserColumnName="Organization" msprop:Generator_ColumnVarNameInTable="columnOrganization" msprop:Generator_ColumnPropNameInRow="Organization" msprop:Generator_ColumnPropNameInTable="OrganizationColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SecurityQuestion" msprop:Generator_UserColumnName="SecurityQuestion" msprop:Generator_ColumnVarNameInTable="columnSecurityQuestion" msprop:Generator_ColumnPropNameInRow="SecurityQuestion" msprop:Generator_ColumnPropNameInTable="SecurityQuestionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SecurityAnswer" msprop:Generator_UserColumnName="SecurityAnswer" msprop:Generator_ColumnVarNameInTable="columnSecurityAnswer" msprop:Generator_ColumnPropNameInRow="SecurityAnswer" msprop:Generator_ColumnPropNameInTable="SecurityAnswerColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Year" msprop:Generator_UserColumnName="Year" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInTable="YearColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Relations_Course-User" msprop:Generator_UserTableName="Relations_Course-User" msprop:Generator_RowDeletedName="_Relations_Course_UserRowDeleted" msprop:Generator_RowChangedName="_Relations_Course_UserRowChanged" msprop:Generator_RowClassName="_Relations_Course_UserRow" msprop:Generator_RowChangingName="_Relations_Course_UserRowChanging" msprop:Generator_RowEvArgName="_Relations_Course_UserRowChangeEvent" msprop:Generator_RowEvHandlerName="_Relations_Course_UserRowChangeEventHandler" msprop:Generator_TableClassName="_Relations_Course_UserDataTable" msprop:Generator_TableVarName="_tableRelations_Course_User" msprop:Generator_RowDeletingName="_Relations_Course_UserRowDeleting" msprop:Generator_TablePropName="_Relations_Course_User">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CourseID" msprop:Generator_UserColumnName="CourseID" msprop:Generator_ColumnPropNameInRow="CourseID" msprop:Generator_ColumnVarNameInTable="columnCourseID" msprop:Generator_ColumnPropNameInTable="CourseIDColumn" type="xs:int" />
              <xs:element name="SectionNumber" msprop:Generator_UserColumnName="SectionNumber" msprop:Generator_ColumnPropNameInRow="SectionNumber" msprop:Generator_ColumnVarNameInTable="columnSectionNumber" msprop:Generator_ColumnPropNameInTable="SectionNumberColumn" type="xs:int" />
              <xs:element name="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" type="xs:int" />
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SortOrder" msprop:Generator_UserColumnName="SortOrder" msprop:Generator_ColumnPropNameInRow="SortOrder" msprop:Generator_ColumnVarNameInTable="columnSortOrder" msprop:Generator_ColumnPropNameInTable="SortOrderColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users_NonInstitute_Activation" msprop:Generator_UserTableName="Users_NonInstitute_Activation" msprop:Generator_RowDeletedName="Users_NonInstitute_ActivationRowDeleted" msprop:Generator_RowChangedName="Users_NonInstitute_ActivationRowChanged" msprop:Generator_RowClassName="Users_NonInstitute_ActivationRow" msprop:Generator_RowChangingName="Users_NonInstitute_ActivationRowChanging" msprop:Generator_RowEvArgName="Users_NonInstitute_ActivationRowChangeEvent" msprop:Generator_RowEvHandlerName="Users_NonInstitute_ActivationRowChangeEventHandler" msprop:Generator_TableClassName="Users_NonInstitute_ActivationDataTable" msprop:Generator_TableVarName="tableUsers_NonInstitute_Activation" msprop:Generator_RowDeletingName="Users_NonInstitute_ActivationRowDeleting" msprop:Generator_TablePropName="Users_NonInstitute_Activation">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" type="xs:int" />
              <xs:element name="ActivationCode" msprop:Generator_UserColumnName="ActivationCode" msprop:Generator_ColumnVarNameInTable="columnActivationCode" msprop:Generator_ColumnPropNameInRow="ActivationCode" msprop:Generator_ColumnPropNameInTable="ActivationCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:UserID" />
    </xs:unique>
    <xs:unique name="Users_NonInstitute_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users_NonInstitute" />
      <xs:field xpath="mstns:UserID" />
    </xs:unique>
    <xs:unique name="Relations_Course-User_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Relations_Course-User" />
      <xs:field xpath="mstns:CourseID" />
      <xs:field xpath="mstns:SectionNumber" />
      <xs:field xpath="mstns:UserID" />
    </xs:unique>
    <xs:unique name="Users_NonInstitute_Activation_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users_NonInstitute_Activation" />
      <xs:field xpath="mstns:UserID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Relations_Course_User-Users" msdata:parent="Users" msdata:child="Relations_Course-User" msdata:parentkey="UserID" msdata:childkey="UserID" msprop:Generator_UserRelationName="FK_Relations_Course_User-Users" msprop:Generator_RelationVarName="_relationFK_Relations_Course_User_Users" msprop:Generator_UserChildTable="Relations_Course-User" msprop:Generator_UserParentTable="Users" msprop:Generator_ParentPropName="UsersRow" msprop:Generator_ChildPropName="_GetRelations_Course_UserRows" />
      <msdata:Relationship name="FK_Users_NonInstitute_Activation-Users" msdata:parent="Users" msdata:child="Users_NonInstitute_Activation" msdata:parentkey="UserID" msdata:childkey="UserID" msprop:Generator_UserRelationName="FK_Users_NonInstitute_Activation-Users" msprop:Generator_RelationVarName="_relationFK_Users_NonInstitute_Activation_Users" msprop:Generator_UserChildTable="Users_NonInstitute_Activation" msprop:Generator_UserParentTable="Users" msprop:Generator_ParentPropName="UsersRow" msprop:Generator_ChildPropName="GetUsers_NonInstitute_ActivationRows" />
      <msdata:Relationship name="FK_Relations_Course_User-Users1" msdata:parent="Users_NonInstitute" msdata:child="Relations_Course-User" msdata:parentkey="UserID" msdata:childkey="UserID" msprop:Generator_UserRelationName="FK_Relations_Course_User-Users1" msprop:Generator_RelationVarName="_relationFK_Relations_Course_User_Users1" msprop:Generator_UserChildTable="Relations_Course-User" msprop:Generator_UserParentTable="Users_NonInstitute" msprop:Generator_ParentPropName="Users_NonInstituteRow" msprop:Generator_ChildPropName="_GetRelations_Course_UserRows" />
      <msdata:Relationship name="FK_Users_NonInstitute_Activation-Users1" msdata:parent="Users_NonInstitute" msdata:child="Users_NonInstitute_Activation" msdata:parentkey="UserID" msdata:childkey="UserID" msprop:Generator_UserRelationName="FK_Users_NonInstitute_Activation-Users1" msprop:Generator_RelationVarName="_relationFK_Users_NonInstitute_Activation_Users1" msprop:Generator_UserChildTable="Users_NonInstitute_Activation" msprop:Generator_UserParentTable="Users_NonInstitute" msprop:Generator_ParentPropName="Users_NonInstituteRow" msprop:Generator_ChildPropName="GetUsers_NonInstitute_ActivationRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>